SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002933s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499378 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499378 [ RunTime:0.004272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397240,1002785,958339,385489,762299,187632,418580,659674,355309,441690,205873,414111,1016920,971118,849115,11823,484541,330034,121302,875736,12794,997217,887860,804297,388212,248757,441972,875075,76524,842584,731103,944444,362751,387482,435653,464020,549188,51590,382697,91954,701396,192381,242923,830635,407168,451188,87515,932663,873832,964019,467347,909521,900951,443137,982641,990469,116782,630563,747588,506345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]