SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540840 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540840 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937544,426480,715869,970583,840293,811473,646172,514952,655742,460614,950128,529841,344549,339458,234637,872421,830661,622008,185458,117220,602827,17122,269243,395245,693548,254743,366199,915665,202508,894750,909462,983732,829503,526087,177376,859429,890624,253177,813504,208551,678762,254304,521559,991797,641343,282423,341938,586403,387606,569861,895342,947807,955993,939119,226347,794312,518757,563342,363027,337841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]