SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4420 LIMIT 1 [ RunTime:0.001613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4420 [ RunTime:0.003218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646753,703056,888887,791535,597973,968004,213972,88038,529846,293238,863279,484332,438894,129841,283798,214233,282231,686182,956535,2980,922763,733741,994867,260721,383280,994685,216048,133887,503047,508636,173283,490134,414247,552697,1005729,1014807,158993,850026,465877,252198,689189,599382,796763,1032268,982548,332250,20268,640641,962922,194028,430949,422113,141364,721727,830763,371546,508338,548318,905803,889238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000987s ]