SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475015 LIMIT 1 [ RunTime:0.004511s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475015 [ RunTime:0.007072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199986,55903,161653,276947,312721,604333,6825,379956,288387,624918,792619,722067,987277,330288,500038,774101,732039,361091,617958,325198,170315,876960,563652,469375,139541,613851,570450,411402,769462,622619,568862,615124,16708,1016229,601003,968936,92098,405137,871561,752710,53103,308883,504671,632779,878559,161990,516756,365068,992953,371542,959250,1028608,677678,540879,553381,772224,829305,151157,113641,139814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]