SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501948 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501948 [ RunTime:0.002900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152227,99824,134831,577478,777204,842589,137878,290644,980540,1048334,862923,246015,953203,252373,220751,432133,916171,191,985565,354164,513951,156441,970426,783724,792489,16109,182284,565935,209303,123270,1030307,179246,441903,152889,694203,349483,283826,874708,379160,557398,753442,752450,685137,302353,373234,904438,821124,588908,461761,398570,88350,858152,114671,830745,583464,479140,465911,442415,740174,896722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]