SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506956 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506956 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368870,583482,604000,434646,284576,646776,1014459,554616,368951,117272,622063,1012853,431970,786336,784473,313325,307880,690311,868974,762323,955481,459435,591614,437506,275857,260683,353466,762223,124718,942548,312179,118934,993578,1039879,66268,248491,160210,139689,909773,827493,676637,847153,416869,370391,187926,241732,651100,352093,852641,46571,302555,905122,156620,111437,372456,183608,897678,836937,549139,790846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]