SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501224 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501224 [ RunTime:0.004112s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133026,246832,761767,1022489,750479,651543,308830,542223,484560,659234,290953,530808,191247,1042177,455650,300063,316118,639688,593479,434828,515692,534441,681714,58414,106397,256018,189828,231396,615754,684410,59675,78639,533769,311896,603187,1027372,889034,941015,678968,325956,773397,539368,84001,642376,468845,3520,403949,836205,568619,197681,732240,1020922,399882,372271,953230,220476,65945,549785,644964,924820) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001856s ]