SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401021 LIMIT 1 [ RunTime:0.001191s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401021 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715773,371061,903225,355915,317116,738730,920577,721520,1019209,851717,242207,195182,1037947,508856,897356,324600,976550,1020870,968368,166651,304492,384175,118843,438355,814341,49583,123187,515810,860029,1047155,225785,985602,975540,797200,831084,277971,473819,894968,325066,896850,652456,636879,440046,1019066,869977,682468,152802,402642,385056,113278,206735,284883,716588,369833,733047,321241,819529,968255,834070,519416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000792s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001416s ]