SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407300 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407300 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400036,1012014,557170,890932,381010,141046,848053,777092,273626,696751,959044,824767,85310,978096,21640,620818,665344,9563,837909,815790,336462,374297,597726,460127,888232,391155,655569,582115,128887,1007676,327322,389724,498217,440726,875279,306684,607021,1029301,862774,366745,595160,936599,407622,494432,1023472,208348,21901,64402,247577,358022,516939,1005660,823939,932815,1031381,35579,366431,1042260,103045,1030493) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]