SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391035 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391035 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28671,281814,264870,63040,682922,295261,134441,540002,361946,707920,175200,274560,656503,465442,212989,739738,706044,558339,137139,534564,544622,104397,505982,162187,992243,547993,835411,915974,468803,531725,192317,601021,772784,64893,792506,352240,483409,823998,980445,453009,463966,683525,509549,981006,846183,727842,965163,195554,490680,492722,608352,905100,789538,92792,917857,944833,540651,947073,599516,291981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]