SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 657503 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 657503 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150819,1004473,802546,986044,877916,1027601,163896,198916,593812,571840,86916,271180,121617,745699,685738,593622,618895,906415,892261,483765,676684,110688,429025,37320,60717,131473,982765,179282,733507,1023514,628214,845519,192439,382644,366722,960063,481596,643159,856774,364028,935477,640797,181903,885353,570665,47874,95491,854400,425379,228518,988828,522829,222023,381734,500122,790582,881296,1014524,108008,574159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 657503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 657503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]