SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299541 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299541 [ RunTime:0.001258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425522,1029923,51588,573111,200950,461611,400724,577635,653690,257217,857544,822861,638209,303341,297779,787845,121050,410429,359829,539090,701645,891083,43687,240715,49116,995107,598007,325121,42758,811491,488017,193021,995212,831164,774489,714623,217514,64583,592125,997817,28151,226605,81198,641267,713889,1031606,538109,810343,87831,298775,79547,582243,254730,978928,318077,711443,583052,441252,715511,610187) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]