SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51840 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51840 [ RunTime:0.006258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60661,936931,498603,69081,438178,925203,809260,556702,167840,1016675,357448,1001091,475044,305164,442854,686400,704202,743198,267790,160994,601358,517661,362868,567690,271520,956095,296660,206421,836484,346172,506200,215444,732174,988609,991756,615273,244870,621671,693837,343009,990234,677706,666564,758064,143717,556491,915394,335506,403222,63127,481542,56923,982547,957635,293534,539082,95316,380677,282404,572914) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001628s ]