SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540610 LIMIT 1 [ RunTime:0.000274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540610 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327893,111735,601870,755786,576409,939257,781809,961872,57171,632142,701924,55955,359294,401741,970299,972356,126953,354287,610493,478308,629650,480545,931828,223415,314981,575945,912878,888575,700653,914677,898706,670575,713976,124111,431790,877496,870489,934351,892522,537656,159234,838424,328633,557981,930033,308577,519059,164560,731505,855344,184987,546775,948670,667831,619717,960065,511926,73797,890513,73930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]