SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530410 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530410 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936002,169281,687632,255168,952581,848360,929747,902431,183103,682808,960409,401713,1045259,138525,634274,178419,2430,896010,750077,672277,589743,152701,367469,296754,857087,440492,25526,979671,406628,73955,973806,684071,240030,670542,1046160,792772,740073,943611,494428,317645,525569,399361,779601,555858,867546,999339,873950,176535,789769,985785,993449,399350,1000892,483875,271935,212647,512787,328231,520591,128161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]