SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101438 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101438 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493676,9642,106404,258914,189518,608628,793428,779945,350781,922000,702421,12387,82340,216018,776416,1029426,905871,423502,701735,344991,790319,451183,718841,382126,880715,726195,852873,768581,946651,145441,881326,14424,589945,583894,868504,566262,39883,794768,63738,372220,222921,638984,790642,765499,1039546,324272,109941,139812,1034183,889933,203884,76843,741766,553892,678792,552581,918190,131038,440167,605057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]