SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455901 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455901 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506027,228198,602493,506686,570099,415998,352602,800656,745002,118674,129851,1047127,362143,930729,295834,612882,1021585,698880,833737,502466,932146,646811,985522,57876,512947,771339,10754,504228,605999,848077,287785,570538,742788,645471,915238,136074,419982,103367,620038,519833,309494,410500,329391,628531,171389,829322,499333,350120,844740,348822,655302,650551,683688,660505,589671,225034,615365,757742,315196,978572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]