SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014894 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014894 [ RunTime:0.002013s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995165,872001,871653,224869,569119,575536,161757,125543,496280,946629,242650,498139,1031587,162952,806376,845060,134143,236553,825081,206977,607191,848911,204483,964273,114589,248060,385230,844438,963601,44107,387121,205751,18333,468701,630723,771201,305359,953,262858,167759,12705,902443,439929,243779,492364,354556,490046,738450,671660,692544,706223,257117,660733,56099,830400,133370,841759,220918,1013985,839531) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]