SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442317 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442317 [ RunTime:0.003290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542388,323004,34202,745535,896678,87968,48175,181870,115987,372411,608637,64587,824591,430320,13840,384018,1022582,891383,762826,681347,339625,438346,792189,224140,583493,823503,433927,870294,340104,358757,747086,44359,210300,207002,26803,410414,686026,179485,559532,498444,725867,638471,391007,341540,663636,879099,206424,721058,542279,64362,398387,169085,955111,1045761,703648,179002,525842,393312,757711,857764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002317s ]